IF OBJECT_ID ('myInsteadOfTrigger', 'TR') IS NOT NULL
          DROP TRIGGER myInsteadOfTrigger
      go

      CREATE TRIGGER myInsteadOfTrigger
        ON      myTable

      INSTEAD OF INSERT, UPDATE, DELETE
      AS
          SELECT 'INSTEAD OF: Trigger Fired on' as TriggerName,
          GETDATE()                             as Date_Time